package com.foreverwin.jzymes.archive.mapper;

import com.foreverwin.jzymes.archive.domain.DataArchive;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface DataArchiveAdviceMapper {

    public int createArchiveTable( @Param("table") String table, @Param("archiveTable") String archiveTable );

    public List<DataArchive> selectDataArchiveList( @Param("referTable") String referTable );

    public List<String> selectTableColumns( @Param("table") String table );

    public List<String> selectArchiveTableColumns( @Param("table") String table );

    public List<Map<String,Object>> buildQuerySql( Map<String,Object> paramMap );

    public int updateArchiveCount( @Param("table") String table, @Param("increment") int increment );

    public int buildInsertSql( Map<String,Object> paramMap );

    public int buildUpdateSql( Map<String,Object> paramMap );

    public int buildDeleteSql( Map<String,Object> paramMap );

    public int buildDeleteArchiveSql( Map<String,Object> paramMap );
}
